alter table [performance].[submit_sale] alter column [sub_group_num] varchar(10);
alter table [performance].[submit_sale] alter column [certificate_num] varchar(10);
alter table [performance].[submit_sale] alter column [basic_plan_vers_num] varchar(2);
alter table [performance].[submit_sale] alter column [coverage_plan_vers_num] varchar(2);
alter table [performance].[submit_sale] alter column [basic_plan_name_eng] varchar(250);
alter table [performance].[submit_sale] alter column [basic_plan_name_chi] nvarchar(250);
alter table [performance].[submit_sale] alter column [coverage_plan_name_eng] varchar(250);
alter table [performance].[submit_sale] alter column [coverage_plan_name_chi] nvarchar(250);
GO
alter table [performance].[submit_sale] drop column [plan_code];
alter table [performance].[submit_sale] drop column [plan_vers_num];
GO

alter table [performance].[issue_sale] alter column [basic_plan_name_eng] varchar(250);
alter table [performance].[issue_sale] alter column [basic_plan_name_chi] nvarchar(250);
alter table [performance].[issue_sale] alter column [coverage_plan_name_eng] varchar(250);
alter table [performance].[issue_sale] alter column [coverage_plan_name_chi] nvarchar(250);
alter table [performance].[issue_sale] alter column [policy_insured_name] nvarchar(101);
alter table [performance].[issue_sale] alter column [policy_owner_name] nvarchar(101);
alter table [performance].[issue_sale] alter column [issue_pc] numeric(9,0) not null;
alter table [performance].[issue_sale] alter column [issue_case_count] numeric(5,2) not null;
alter table [performance].[issue_sale] alter column [sub_group_num] varchar(10);
alter table [performance].[issue_sale] alter column [certificate_num] varchar(10);
alter table [performance].[issue_sale] alter column [policy_plan_type] varchar(10);
GO
alter table [performance].[issue_sale] add [reason_code_desc] [varchar](50) not null default '';
GO
